package com.xyht.sca_s.student_manage_system.modules.questionnaire.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.xyht.sca_s.student_manage_system.modules.questionnaire.entity.SmsQuestionnaireAnalysis;
import com.xyht.sca_s.student_manage_system.modules.user.entity.SmsUser;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Component;

import java.util.Date;
import java.util.List;
import java.util.Map;

/**
 * <p>
 * 数据分析 Mapper 接口
 * </p>
 *
 * @author XYHT
 * @since 2023-02-08
 */
@Component(value = "SmsQuestionnaireAnalysisMapper")
public interface SmsQuestionnaireAnalysisMapper extends BaseMapper<SmsQuestionnaireAnalysis> {
    List<SmsUser> getUserIDBySearchStr(String ques_id,String topic_id, @Param("optionList")List<String> optionList, String user_name,
                                       String option_str, Integer pageSize, Integer offset,
                                       Date bgDate,Date endDate);

    Integer getUserIDBySearchStrCount(String ques_id,String topic_id, @Param("optionList")List<String> optionList, String user_name,
                                       String option_str,Date bgDate,Date endDate);

    List<Map<String, Object>> getOptionNameListByID(String topic_id, String user_id);
}
